Tabela EMail

Definicja tabeli EMail

Name

EMail

Code

EMail

Comment

 


Lista kolumn tabeli EMail

Name

Code

EMailID

EMailID

MessageID

MessageID

MessageTypeID

MessageTypeID

UserLogin

UserLogin

Mode

Mode

UID

UID

Sender

Sender

Receivers

Receivers

ReceiveDate

ReceiveDate

SendDate

SendDate

Subject

Subject

Body

Body

AttachmentName

AttachmentName

AttachmentSize

AttachmentSize

AttachmentStorePath

AttachmentStorePath

AttachmentContent

AttachmentContent

ModificationNo

ModificationNo

TransferTimeInMs

TransferTimeInMs

pop3Uid

pop3Uid


Kolumna EMailID tabeli EMail

Definicja kolumny EMailID tabeli EMail

Name

EMailID

Code

EMailID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna MessageID tabeli EMail

Definicja kolumny MessageID tabeli EMail

Name

MessageID

Code

MessageID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna MessageTypeID tabeli EMail

Definicja kolumny MessageTypeID tabeli EMail

Name

MessageTypeID

Code

MessageTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UserLogin tabeli EMail

Definicja kolumny UserLogin tabeli EMail

Name

UserLogin

Code

UserLogin

Data Type

VARCHAR2(25)

Mandatory

No

Comment

 


Kolumna Mode tabeli EMail

Definicja kolumny Mode tabeli EMail

Name

Mode

Code

Mode

Data Type

VARCHAR2(15)

Mandatory

No

Comment

 


Kolumna UID tabeli EMail

Definicja kolumny UID tabeli EMail

Name

UID

Code

UID

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna Sender tabeli EMail

Definicja kolumny Sender tabeli EMail

Name

Sender

Code

Sender

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna Receivers tabeli EMail

Definicja kolumny Receivers tabeli EMail

Name

Receivers

Code

Receivers

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna ReceiveDate tabeli EMail

Definicja kolumny ReceiveDate tabeli EMail

Name

ReceiveDate

Code

ReceiveDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna SendDate tabeli EMail

Definicja kolumny SendDate tabeli EMail

Name

SendDate

Code

SendDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna Subject tabeli EMail

Definicja kolumny Subject tabeli EMail

Name

Subject

Code

Subject

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna Body tabeli EMail

Definicja kolumny Body tabeli EMail

Name

Body

Code

Body

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna AttachmentName tabeli EMail

Definicja kolumny AttachmentName tabeli EMail

Name

AttachmentName

Code

AttachmentName

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna AttachmentSize tabeli EMail

Definicja kolumny AttachmentSize tabeli EMail

Name

AttachmentSize

Code

AttachmentSize

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna AttachmentStorePath tabeli EMail

Definicja kolumny AttachmentStorePath tabeli EMail

Name

AttachmentStorePath

Code

AttachmentStorePath

Data Type

CLOB

Mandatory

No

Comment

 


Kolumna AttachmentContent tabeli EMail

Definicja kolumny AttachmentContent tabeli EMail

Name

AttachmentContent

Code

AttachmentContent

Data Type

BLOB

Mandatory

No

Comment

 


Kolumna ModificationNo tabeli EMail

Definicja kolumny ModificationNo tabeli EMail

Name

ModificationNo

Code

ModificationNo

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna TransferTimeInMs tabeli EMail

Definicja kolumny TransferTimeInMs tabeli EMail

Name

TransferTimeInMs

Code

TransferTimeInMs

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna pop3Uid tabeli EMail

Definicja kolumny pop3Uid tabeli EMail

Name

pop3Uid

Code

pop3Uid

Data Type

VARCHAR2(77)

Mandatory

No

Comment

Pole UIDL - unique-id listing


Lista kluczy tabeli EMail

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli EMail

Definicja klucza Identifier_1 tabeli EMail

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment